| SyIndexRecreatePostUpgradeWork |
| EntityType | Independent |
| Logical Entity Name | SyIndexRecreatePostUpgradeWork |
| Default Table Name | SyIndexRecreatePostUpgradeWork |
| Logical Only | NO |
| Definition | |
| Note |
| SyIndexRecreatePostUpgradeWork Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
SyIndexRecreatePostUpgradeWorkID |
INTEGER | NO | ||
| SchemaName | NVARCHAR(128) | YES | ||
| TableName | NVARCHAR(128) | YES | ||
| ObjectId | INTEGER | YES | ||
| IndexName | NVARCHAR(128) | YES | ||
| DataSpaceID | INTEGER | YES | ||
| ColumnName | NVARCHAR(128) | YES | ||
| ColumnId | INTEGER | YES | ||
| IndexTypeDesc | NVARCHAR(60) | YES | ||
| IndexColumnId | INTEGER | YES | ||
| IndexKeyOrdinal | TINYINT | YES | ||
| IndexPartitionOrdinal | TINYINT | YES | ||
| IsDescendingKey | BIT | YES | ||
| IsIncludedColumn | BIT | YES | ||
| IsUnique | BIT | YES | ||
| IsPadded | BIT | YES | ||
| IgnoreDupKey | BIT | YES | ||
| IsDisabled | BIT | YES | ||
| AllowRowLocks | BIT | YES | ||
| AllowPageLocks | BIT | YES | ||
| IndexFillFactor | TINYINT | YES | ||
| IsFilteredIndex | BIT | YES | ||
| FilterDefinition | NVARCHAR(max) | YES | ||
| bDropped | BIT | YES | ||
| DateAdded | DATETIME | YES | ||
| DateLstMod | DATETIME | YES |
| SyIndexRecreatePostUpgradeWork Keys |
| Key Name | Key Type | Keys |
| PK_SyIndexRecreatePostUpgradeWork_SyIndexRecreatePostUpgradeWorkId | PrimaryKey | SyIndexRecreatePostUpgradeWorkID |
| SyIndexRecreatePostUpgradeWork Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SyIndexRecreatePostUpgradeWork Check Constraints |
| Check Constraint Name | CheckConstraint |